SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407420 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407420 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014058,521306,1018981,116080,891139,581824,111006,559507,150417,819279,877996,228393,373246,1034397,690004,959587,880210,108250,391158,361456,281451,253276,737691,494306,915770,515171,834075,344517,612242,778205,297039,732340,39996,988578,942777,575843,238206,867361,702091,876845,577201,372183,815807,781509,98152,293344,242792,315770,453844,470162,70033,744983,135246,417235,765406,337039,161135,408042,1021771,629083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]