SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19509 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19509 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376158,818101,50530,186281,814321,806601,556747,488612,403865,940713,523959,227864,196156,923938,1032867,693121,165670,311582,1011643,124131,998369,25927,551914,836672,743390,834958,661972,222638,450075,128299,732524,127716,428671,576148,714412,458060,422191,596713,217797,441765,941516,124022,682760,861056,664867,809338,244737,777476,587106,583636,20710,1030632,1044885,351334,205143,806151,924871,311062,743415,221737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]