SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017227 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017227 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405821,797567,374711,4037,29162,733995,247044,138265,880878,909178,565771,1011613,972261,189562,614090,416443,222352,107234,216323,509393,1019558,553191,753183,299234,447894,339990,99354,1048224,718031,205946,36545,536151,526320,718908,40903,518592,567578,375007,785402,558375,951225,21679,890104,193358,798813,860824,151875,874507,644280,231982,966095,21281,246105,440806,938826,133045,598179,556058,563144,805779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]