SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517204 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517204 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245787,96459,782467,295145,1041012,523828,139805,728824,2938,593467,24301,153706,128885,523933,718966,317775,313391,336418,604911,601147,870021,593890,454321,547228,973431,468760,892750,547957,993731,99626,707686,619307,7423,804790,17574,175171,1048234,996059,601044,47224,180735,295661,284180,997632,910449,852773,439577,840440,675436,713383,555201,75842,377068,98062,824888,743089,136115,359287,891744,875733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]