SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564847 LIMIT 1 [ RunTime:0.000626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564847 [ RunTime:0.002858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453062,910429,1040939,817859,212779,319043,241010,527324,903090,1007954,262112,554693,1037805,14284,278918,201986,512002,477468,788001,784823,426795,736628,752206,372609,856522,999688,171964,192960,283478,542090,725582,620201,189224,1012638,421008,94098,857827,450359,491028,627818,944764,892124,230497,423152,668461,827010,924602,554694,443548,257683,440759,593487,191855,235936,797270,686111,369798,368829,365713,322716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]