SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018247 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018247 [ RunTime:0.002359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143734,876436,112295,293054,125323,164642,713602,337596,1009974,338877,118266,569531,365895,200588,259394,708409,759474,939182,249180,24481,1025168,900422,607328,725991,989228,843902,210529,629979,109602,529194,1134,474862,985537,569334,284065,192694,477130,730382,873885,609983,370792,52959,554325,313123,534691,264319,573107,584514,1038971,330476,226110,969705,75920,1008874,922936,149993,492917,269031,705296,470443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]