SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28052 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28052 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512009,378344,643428,842233,564675,558929,580752,949686,159428,832489,716431,923909,344974,796711,885857,790910,932498,870097,1040324,1004074,207295,397437,189148,336017,861777,179311,452,468080,245117,883920,706386,31623,827987,247371,280358,1029306,637418,170078,485185,596224,1018397,266244,941457,251125,388568,367815,572942,888282,510739,373613,121333,595697,343024,846298,572718,55696,354597,857807,950075,404539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000927s ]