SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017117 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017117 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946367,958172,64578,737602,529281,561455,702172,525132,759199,800603,655692,199774,120974,470916,622208,1035937,797480,296521,339631,117673,1006527,412462,572952,602691,135568,844288,681847,526584,498048,270024,588621,574787,962490,263932,462921,577477,202269,867879,601705,495868,759778,234102,770296,509370,119870,264033,539045,466105,956742,15321,627007,91917,83447,719048,22155,10636,749112,1033071,144394,500733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]