SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020436 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020436 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380718,233039,82244,945371,825775,270281,955839,1034491,736242,491903,542668,927739,983469,644755,304973,611929,1026084,674010,828233,513036,435201,704357,468803,362828,96507,987302,221653,936293,499194,867687,707710,941004,295041,852066,322831,429313,367854,22505,652038,152418,544582,581910,788421,925832,895356,644882,150138,233104,249333,2468,100118,9184,994562,684064,883865,87692,213409,114114,444683,674006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]