SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 605218 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 605218 [ RunTime:0.002395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956630,52234,82424,387466,483822,581947,970007,761093,449432,877455,267597,92131,330369,903352,226585,131863,513108,159377,448325,957402,691323,179464,88980,713327,512456,153757,27210,1047386,501761,548336,478744,295711,576259,997713,377834,765074,555626,266773,465150,229432,434018,915220,708790,135711,251552,1040719,223578,796339,1188,767738,371055,527261,115348,797947,589866,777350,747098,636582,849705,645825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 605218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 605218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]