SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528983 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528983 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450032,284840,870154,986074,1036985,208855,462560,310199,668875,433822,343533,165859,963484,581876,47687,79295,107351,739533,343615,646350,123968,391902,132890,423388,887489,1026488,518506,299834,1044481,271080,405380,187180,630590,144489,448517,966569,458030,1046156,768459,932546,607054,230430,457759,786901,842868,80169,268339,655704,621571,217066,864713,11817,463002,542027,1039266,121860,830646,1021824,439905,360823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]