SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 222151 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 222151 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496836,118690,947501,746405,221624,465023,2510,252906,934899,812386,737102,798778,101936,684099,358485,121503,942758,347087,363051,967255,918113,106143,908225,251991,311338,818223,835248,774372,6900,816181,338583,860486,537307,250318,693612,437513,253395,489916,1036100,1697,562870,746080,453566,390709,751580,486286,643971,834621,886108,422990,227447,542884,330956,349856,503674,255156,785358,175534,279195,534466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 222151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 222151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]