SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408036 LIMIT 1 [ RunTime:0.000870s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408036 [ RunTime:0.006313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027534,629798,101042,295906,821787,357442,404928,341442,138656,132652,330035,839357,880341,94895,277319,325006,588328,801414,336075,127119,1046296,855041,699523,592206,330774,519165,114644,75587,563738,595155,436349,959477,55886,839265,314431,1046609,403724,247407,235618,337347,145540,947973,454283,83610,761511,499601,610306,201899,170045,332694,181598,317999,395937,188223,167956,594730,711732,1005280,228465,889568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001775s ]