SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200516 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200516 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895118,249080,725131,181341,93087,596706,722530,408189,785841,77867,790448,702504,890551,679559,11672,140017,816905,314061,523424,831869,718489,300689,321918,883778,580244,139052,264860,459013,66116,930096,94098,187657,919741,403463,27579,841650,61175,715821,67433,677560,993714,979103,1041940,381309,246597,351423,377585,88594,229937,1001805,674243,343284,154381,424514,185669,993308,527292,181455,241010,72997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]