SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010455 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010455 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255563,283598,750120,945353,590417,282979,238761,907792,1011047,600717,195763,607231,417792,424625,513522,8134,61899,856074,765002,223924,622825,837774,25453,22689,380204,786240,339521,473524,581404,887816,279047,76415,191152,392726,323044,1014851,728806,978532,214067,522839,779288,308950,571341,471568,474001,747693,147203,1007219,423608,394757,195138,898300,704311,29569,31100,220839,311294,252444,451392,499913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]