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` = 127218 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 127218 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629047,1011327,677426,649935,1041137,345869,71161,408410,685588,126097,1021814,962510,165434,589212,70822,912890,4200,465051,1007563,119651,764135,791145,160354,687790,1044501,1024165,21254,1017192,972130,287244,824519,687262,367462,521577,711400,199708,631001,1018503,596260,733747,288084,231686,455500,32031,554779,619845,298834,627592,239145,7611,135691,483227,304883,227763,429352,943763,713735,694029,460603,895096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 127218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 127218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]