SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475799 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475799 [ RunTime:0.005124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345521,148981,839309,1044594,411998,703492,866179,588389,955239,116022,503274,559615,773636,275434,141437,176426,412933,895665,201744,585873,828136,862350,220734,276042,115664,631052,282861,10500,574441,988056,619629,471452,271054,1046349,814854,154156,333767,150751,597184,688645,109256,465963,867608,350048,44124,113449,750674,407500,418646,204367,357359,441709,393948,353214,583491,236354,513656,989957,71276,240105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]