SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203141 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203141 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654387,1046850,422961,296721,719205,623797,310315,661039,217004,861706,931022,616754,900852,712653,564089,587980,42623,498047,442712,256358,397214,19223,960879,814279,592496,228700,338518,663608,241322,297080,811595,584624,1021618,937180,774781,277862,514463,382895,551966,364699,749229,31968,705585,491812,1001232,678693,48292,196997,672853,653405,737478,567988,695399,562000,832704,259994,384269,556995,107892,810155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]