SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284346 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284346 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512114,862284,231312,204217,736845,312450,785022,326575,636089,198460,141452,749561,285440,343469,626438,821330,291667,182512,797350,507158,1002054,712937,808433,398155,452434,169928,371734,624297,599976,758029,359130,654190,1033806,1035727,275069,445950,937246,496658,419986,406715,560163,251320,101610,1019790,644656,989300,208141,151708,36839,879082,666821,428511,96149,904965,182953,457442,829377,730912,471806,375216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]