SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 214518 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 214518 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100214,333160,84915,425443,411880,392397,995354,724081,692308,426663,755812,225418,47192,95043,518313,566151,451184,717689,80446,263252,761007,349277,656318,980215,197670,844283,965912,790365,4202,175224,886284,493929,701669,487414,447120,733046,907997,634292,142473,133643,81075,332943,822564,137260,213837,485336,258611,520389,746705,388661,1022608,800588,931314,151318,944944,682709,32592,666114,39844,172373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 214518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 214518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001533s ]