SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438414 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438414 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150940,950229,511422,395856,631110,726185,667084,1015898,721262,401101,333909,511033,919700,82453,146765,138689,302157,552320,543321,569099,946895,545471,706155,243908,817850,162828,266451,359885,1021956,274567,735285,605856,191146,714366,27133,44614,940442,44699,931622,870990,213012,603376,414022,981159,446656,863929,803873,599332,669601,17342,602121,86090,490337,900440,983786,604029,631383,502209,994021,183997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]