SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346670 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346670 [ RunTime:0.002731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455791,84023,311535,507322,110831,444837,790958,683313,454716,91516,944178,714079,55142,935805,335046,950283,9088,986508,106779,66882,260871,517857,371358,541722,150892,811492,550210,1039558,213560,790975,16502,357058,647149,799300,188017,876836,964109,987779,410283,278220,107184,478839,668191,615821,195499,598378,852855,402828,747751,148321,363536,556445,380876,101791,784449,196016,965784,5768,462314,1010612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]