SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206850 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206850 [ RunTime:0.002817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001782,488603,175165,938292,845922,180603,472615,655789,382061,766097,733665,479138,401130,602780,991875,361040,211254,335517,229519,916867,437932,931971,730406,643036,977536,502183,762082,285423,783058,112391,504613,1025848,798312,935504,611927,231802,529750,824111,1006694,391154,440824,686060,788961,505982,411720,983256,431283,675961,916678,764987,485700,959572,383621,536240,931734,901161,586685,309140,890470,356611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]