SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498615 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498615 [ RunTime:0.005721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494168,93736,641918,63203,503254,256727,818011,81127,310046,625546,384027,486627,702325,916737,190447,941769,123851,205180,351190,1009655,831472,789909,244213,257978,212483,944167,137782,1023547,315598,615722,627297,697743,99382,434187,528932,43846,567061,974293,989076,994059,748629,845638,614428,770160,495106,345369,973142,1038644,794298,260951,1020639,132619,143735,1016930,843995,353968,314463,707267,61008,373339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]