SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002560s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335603 LIMIT 1 [ RunTime:0.000647s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335603 [ RunTime:0.002423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251428,197373,228663,452051,307969,235145,935827,50545,783941,332979,224744,897992,503391,335466,142691,65532,205909,235317,89634,100993,40914,169687,305890,631829,789263,484374,899837,74174,1002846,508352,534305,729415,572227,346866,354382,940257,76822,707646,585161,673756,210657,669463,936287,319888,659345,543181,59850,394262,1036734,886835,123340,936973,547943,712061,332541,619571,273607,590789,646330,52861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]