SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392913 LIMIT 1 [ RunTime:0.001794s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392913 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535106,234739,501864,895707,735740,669015,748549,863299,1009793,1014476,172193,63511,467270,338267,303415,292627,934781,668634,421223,751337,1041308,455765,459442,928372,260348,234393,1029560,988210,634459,334956,551106,463230,119543,420190,471715,810235,646238,714098,459854,574321,517635,348817,762518,395214,662254,199113,675212,754654,871257,418673,492611,34013,778048,962222,580028,888094,124166,830610,214583,810498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]