SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549938 LIMIT 1 [ RunTime:0.001357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549938 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368946,587314,664155,441098,401591,642476,306805,872165,328120,14593,689491,394555,79049,185790,409095,1003047,70888,999637,1021602,866122,108395,485175,302526,618085,641201,191232,576877,988998,238777,571858,111697,165116,759145,130469,724130,182411,1023676,647184,322172,947932,612708,73772,423199,380234,870983,153005,706378,76224,928496,597171,665547,451416,166566,268835,182469,656227,3185,973940,520521,715110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]