SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507111 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507111 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71215,509359,221483,510559,377156,54816,858851,592436,1016692,672178,986431,699133,841708,944746,252451,657378,406432,245629,284778,169546,882162,425123,879905,948099,557076,857169,631522,142130,852353,51443,923411,688929,689455,578747,606925,292240,378540,888007,166168,177484,172871,531105,922213,57771,150074,803642,387487,808872,250300,669325,429483,523971,1035612,609905,466510,77521,235471,931317,602075,291209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]