SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804071 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804071 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043804,926315,999332,380328,794375,594891,616804,812291,770963,94455,937645,269671,380784,934447,718630,828893,613823,270619,990399,850302,626975,901357,737558,804491,323112,215919,116377,186499,884864,643961,312168,772003,294548,1043507,771940,287923,972524,768801,988387,755783,90314,580617,304727,396832,299048,673790,993714,880256,256955,271541,542163,237441,904059,249938,880217,168186,768931,737349,986691,394323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]