SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505256 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505256 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445592,613782,951202,442114,427000,294319,720366,149642,145808,123465,742348,583574,581825,83886,29126,847249,99943,404548,342053,46611,396004,190698,335744,319840,725445,531454,681332,354933,972276,795437,610361,1014089,880612,736251,1021434,582813,245083,1001542,325850,453867,981918,206036,342728,12633,443944,528909,83295,925359,809714,386196,182575,668812,459460,711782,642574,30555,1001879,949006,157820,216475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505256 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002859s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505256 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]