SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403722 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403722 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296811,229912,511068,672669,29863,991335,601423,14013,291135,911700,148681,902696,968835,623921,981428,257524,968868,519783,918846,406277,201966,746806,178438,591097,160591,41420,737675,674083,983597,285832,522813,227151,232,1037514,481931,1004463,567856,833610,31126,136179,359020,639196,313742,156023,835383,103753,618878,196240,234821,154245,496980,333400,188970,164499,595968,816546,129623,251333,894934,413720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001059s ]