SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541982 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541982 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545741,635564,82476,1001405,694142,536254,44149,600893,927090,908567,400272,729812,123630,453562,95429,59053,309165,587385,937095,216146,519279,480618,71148,261040,671592,342564,599911,935694,300356,589950,1045930,686500,478739,627862,892905,561395,176773,236370,561004,999835,52923,224912,287344,647344,897360,796366,945657,472624,477893,252942,747232,108811,1004308,875251,662591,515404,612322,388366,334459,471539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]