SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436748 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436748 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575630,529850,676161,997775,973444,208849,531352,959603,965298,173302,829632,139629,38490,955831,361284,47283,456879,345023,859015,682754,411810,897466,969318,636306,161460,141990,421498,835386,276415,729123,571790,656658,630335,753013,355296,96300,383113,248514,891961,848279,319400,404098,476278,482024,283872,443906,1034743,700252,365692,269107,1037022,791976,165113,88495,1035530,206142,753469,696175,848819,483873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]