SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484526 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484526 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961875,14446,524572,893504,967165,524282,74115,238444,876236,931318,498804,391471,268441,117431,805919,1029983,733416,331153,927327,937781,363934,740078,818231,607454,772704,801982,849945,940353,864888,648079,918993,330980,856865,1017650,576828,15075,631774,234368,769441,674965,829175,104810,819844,180495,169562,805860,353566,15744,190485,1035930,556050,892818,964151,981595,436615,205724,744487,167243,405137,950307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]