SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430438 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430438 [ RunTime:0.002937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830629,109366,20048,425784,529842,902420,137939,209460,232809,485277,157683,926303,646680,1027757,293165,449512,713580,583829,281244,99787,867062,977472,340296,185196,523678,513145,291619,210282,714491,163730,979171,621512,417166,747017,1038374,206838,197385,521820,502469,785305,586142,977324,636583,240393,866588,1009756,1004706,115850,1020476,627921,713504,792803,706203,822261,820164,284280,640743,877566,187656,212861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]