SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546241 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546241 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277749,131000,579334,340833,19501,1037906,326688,262820,197593,431818,783655,281284,849663,141869,449464,479417,417114,544054,951704,24321,495150,207545,663052,679351,387712,662597,101621,581475,481510,326251,815872,1039253,580960,578501,728851,858923,255219,423302,602017,131140,64414,540654,655666,129537,583725,466760,697872,800131,404206,690695,715482,699803,832650,1048898,780029,171026,220112,936864,489973,168604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]