SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002951s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983080 LIMIT 1 [ RunTime:0.001992s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983080 [ RunTime:0.004538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497087,34106,73103,657705,564230,281837,82045,119942,912266,774491,280205,628346,104556,576972,332618,7713,774385,394208,660589,379819,948671,984031,565117,117018,259487,162379,471753,811743,840350,800642,359661,712851,526883,191107,241620,453346,711702,1008122,332310,778163,404103,978324,42380,153264,1020502,925778,201723,297509,986603,104719,373230,918784,597449,317427,401328,75181,227916,564647,428517,373399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]