SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470510 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470510 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949382,287934,491295,496911,149099,237834,734785,110443,124303,531678,147926,423942,663734,884784,145132,340861,69415,1041924,306235,666275,368358,160220,345787,284856,579574,808908,902657,1017847,294454,814940,864299,285473,344351,735023,417839,673654,985832,335280,428686,965734,999208,665057,487161,189528,656421,881679,934731,996896,495508,138179,84002,1005515,234217,848224,84161,391283,438789,317858,1036501,610332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]