SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022656 LIMIT 1 [ RunTime:0.001535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022656 [ RunTime:0.004595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385934,234338,493238,742773,569180,636840,973067,331588,454587,617634,467842,33445,525634,371659,891193,1029042,557035,535599,800115,388195,135022,739207,623623,153998,168468,945565,854992,243953,263191,284420,66504,104757,309739,254219,314757,744182,1019284,571463,802721,271203,675007,635624,367360,874960,961731,469840,151808,104070,204548,603076,207911,724957,710651,240315,173118,1041888,954790,762756,787229,34790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001235s ]