SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035312 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035312 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299959,347490,557605,455610,321605,1006017,480892,824179,656529,993621,964139,988543,135281,955611,977555,266124,812792,807544,61113,36834,427620,1016757,372890,376792,880223,646466,872966,680639,476381,708645,349636,22469,499856,579032,726487,1037845,194644,1032174,270566,152622,563121,462818,694376,70092,467086,94972,609279,717753,617582,809812,572045,137105,432932,568766,29825,338235,261728,935128,908531,872376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]