SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509599 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509599 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010734,966956,582075,723723,131401,703549,289208,620218,681204,615233,109126,108308,123335,189003,738,72356,691565,466514,256194,636074,222980,1019959,146820,908405,381416,889113,219941,561263,343755,138548,61839,452351,899487,837893,726386,347048,875474,630368,853641,399025,348605,348979,599969,382310,865795,537884,143381,297375,48568,634947,316770,36880,7206,335509,980816,523711,859563,212313,512833,319768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]