SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034107 LIMIT 1 [ RunTime:0.001076s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034107 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844990,693613,250456,922933,865985,548411,290568,851607,534380,1047892,176528,281136,170448,767057,777056,422590,984839,743714,1032741,203180,551439,955782,855369,542021,434191,806935,418380,588561,628984,967108,191617,33648,716819,313608,644272,952445,171768,633401,506860,946026,221520,733183,490794,1021041,239242,409309,362039,650982,272631,320368,679245,86694,377890,428192,430766,406443,690505,740828,670166,550984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]