SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314414 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314414 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135199,217386,248624,969319,200386,685783,825796,797689,241817,462402,470677,535155,606492,693777,759100,793625,158917,144426,516174,593126,41581,721887,964776,377569,357640,691386,58388,248248,185900,584891,391158,1024757,788909,469153,361888,451510,317320,1028586,786584,582300,280235,819217,45185,689843,166810,14940,382056,52737,1003429,690588,1040596,497151,589456,879762,773149,666418,917361,640403,173053,508913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]