SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003043 LIMIT 1 [ RunTime:0.000894s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003043 [ RunTime:0.003069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489237,719768,862379,913686,767057,1031297,1009656,546711,511235,476461,664726,866226,148047,162432,430179,62868,1029673,740681,94339,294395,96707,792489,571948,698710,335924,362377,98936,893194,401795,429493,852037,567971,769519,669723,30758,56664,177534,486040,827077,395476,412641,285719,187901,671246,44481,848677,621142,1028943,951415,999222,23600,579879,517944,1048162,1013986,374586,72977,849793,86412,252097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]