SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555335 LIMIT 1 [ RunTime:0.000646s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555335 [ RunTime:0.003586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857799,179656,484097,38472,733096,555404,327822,261057,895917,183433,312375,337559,758468,903222,865503,354079,489600,370590,109104,970980,275921,42867,407524,650531,967421,504346,94667,531147,841655,475435,184679,950820,543171,264130,453743,596050,1004586,390806,270641,641551,770009,884619,443120,876157,994302,316262,665212,253044,201475,196298,42205,819777,204156,916707,608135,278049,62054,336070,442980,771953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001857s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]