SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043862 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043862 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023439,95447,754687,652622,42909,684218,605646,956885,349164,234621,9242,792442,505483,187485,739770,327747,132715,585387,413127,362697,392856,442586,1018073,757723,372363,806252,161619,444349,568014,280887,586941,177179,434394,817594,499839,793072,254527,64332,196191,68989,628360,234160,172255,316486,1033396,612041,933021,10634,836848,931044,369490,97500,1030117,604049,489094,796717,857822,909210,706208,1033890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]