SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042128 LIMIT 1 [ RunTime:0.001082s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042128 [ RunTime:0.002827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245406,880732,639032,908686,368600,448739,717434,313120,332316,30853,352987,901215,41305,309221,705355,333357,678713,129090,40967,575821,216707,129722,641185,608574,699843,775057,740055,123438,395888,178225,548300,789359,354737,436282,426176,250858,380818,823482,375596,230458,608706,44289,43392,674422,328327,212915,330792,848469,254777,51661,472219,47421,133622,277063,42594,293677,731898,381116,422105,688785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]