SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192690 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192690 [ RunTime:0.003169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24531,1029885,488304,266077,648143,274712,200586,378968,563769,546577,931065,545808,871892,201599,365504,389388,930899,809781,387914,207187,811665,869433,793447,41859,689544,101540,160285,725985,262917,484333,300517,779517,91044,624738,909074,823891,115976,196576,101234,529950,174718,94011,601077,794606,469902,116393,5613,1014357,871125,215205,325274,896233,389425,290064,68489,958619,247070,765299,481405,509850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]