SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474081 LIMIT 1 [ RunTime:0.002360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474081 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138951,794356,853035,789233,1016078,94339,453623,671679,15314,366324,880491,689668,84994,369215,800539,61482,651776,298240,927983,788433,663065,999997,645340,37513,660406,157887,43298,314697,364780,1018967,147295,907789,111317,882733,417474,679087,295959,621205,176547,382993,616876,573383,381911,259516,33320,325540,309807,179998,181825,187267,723149,907062,605750,1023186,805436,1011133,85440,70377,332449,182211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]