SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533837 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533837 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40913,776406,310286,366599,227206,511434,966794,742827,1525,192173,271921,3771,449804,414903,939630,514402,527907,935888,895344,731993,981755,320809,925945,478853,650990,354220,393477,295106,715169,361084,230239,538570,664249,242472,498272,849738,208564,543002,7544,423297,740646,880135,398233,78783,238874,977681,344586,704897,213312,235715,968157,1019099,104082,517972,448332,586506,368013,57673,245058,604665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533837 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533837 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]