SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018928 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018928 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009074,420686,226140,538567,280760,1019489,150102,373409,42386,14685,833943,155066,247893,670938,15116,339717,339229,663307,738953,585059,955200,276168,17157,157887,969814,256245,840965,195639,656524,777173,853748,174865,609991,536011,196612,594328,625329,611957,414390,501943,175055,266668,603630,757907,781528,716919,555813,962889,877606,238842,814073,460413,7751,903631,894036,684157,137154,808693,640212,120090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]