SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534082 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534082 [ RunTime:0.002768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358806,218013,59580,909210,738435,1004833,1021763,762503,649142,478442,841195,215424,45781,436926,411561,730161,163800,308640,872186,547905,71804,617385,727715,647792,904254,899721,407288,887403,732395,996122,827093,721930,996099,196790,591794,534299,27494,781524,467011,1000748,535528,531679,72360,660862,814078,860255,498176,1039309,764263,921472,167712,472090,746267,635175,588670,5515,570264,156314,237487,551358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]