SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301409 LIMIT 1 [ RunTime:0.003489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301409 [ RunTime:0.003497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113609,116994,119566,376063,172305,502306,704967,799411,406645,277739,325179,290700,800429,904217,487876,536718,949027,629103,311522,879607,154849,424089,687880,789409,661685,628180,508440,830303,203681,775829,264587,109163,75791,125850,680427,398529,299837,262481,148584,167127,395115,150708,838692,460449,175070,541021,293525,789569,194998,626261,699674,517335,135904,57446,83996,956537,633464,329474,691054,318723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]