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` = 42514 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42514 [ RunTime:0.005406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864041,332804,37790,632792,886057,988156,864649,702741,746808,402117,397145,593190,521293,160011,353542,906243,156567,946287,239051,103048,180621,1000768,748270,964044,897922,10121,735528,361386,894203,968357,271516,712599,239923,439826,148047,897490,106399,1007574,171628,842314,351098,835712,910652,235492,816346,1013877,214834,650825,556262,443174,426068,740127,75574,974644,1001871,26311,296077,262779,137219,30823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]