SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438924 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438924 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701564,370510,53729,1012963,954722,607980,702977,672037,911535,363752,245307,528294,495542,989835,817385,352541,840718,463803,291432,974613,993388,644203,484269,408873,1016146,926364,7422,501561,972860,280105,878203,887931,577458,699374,598000,557392,232270,337568,750856,30681,53867,527076,94542,60911,167933,1010663,551588,89331,588168,13689,938373,262998,190681,373419,173082,733045,223192,59573,658938,446924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]