SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411408 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411408 [ RunTime:0.004387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349102,728973,260658,883728,309793,805681,840086,414104,428273,1011266,767009,54354,127550,726589,428597,302749,117628,929574,198963,731652,737082,914099,895761,586503,646374,317773,830739,750484,860269,896903,304504,360609,115260,584372,48308,388013,11960,83880,709890,703997,929848,457244,700273,245805,99049,195748,791054,89305,852863,208468,715412,979702,554487,399520,940398,135447,372857,515703,143983,320732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002637s ]