SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537056 LIMIT 1 [ RunTime:0.000946s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537056 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720166,221048,505820,950408,176061,366678,34394,972375,734537,512516,596344,996514,390378,43850,530042,535328,249876,632496,267383,457007,530612,748583,339039,730040,414959,590644,630857,506027,891015,123865,262180,90359,508255,911280,481179,74547,742570,160086,292673,138103,538837,366943,254506,187126,573025,815707,357141,247279,74707,913464,675477,125962,293522,178714,9412,361288,620911,155577,190879,412945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]