SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429976 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429976 [ RunTime:0.003004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76100,774325,1040392,290070,739417,314307,894823,710615,757767,810291,166809,30059,676462,604705,789726,516433,963151,596291,935017,841915,108835,93013,644099,188882,157519,200919,287149,643669,291618,426457,574302,744505,770151,816483,88347,214657,477052,824223,533628,997051,922249,192323,17994,962087,159519,683359,465608,1037128,662475,670153,587516,184448,827363,762079,854794,1031536,969168,849192,492914,305583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]