SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429507 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429507 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499302,488265,297032,997447,100317,273203,457688,372489,751566,887721,390850,908755,885882,450052,806876,337746,19066,106773,1027858,641664,127100,430268,743687,760343,432745,961266,937584,80660,25934,700245,385975,1009015,934360,617792,755846,296140,169520,278584,441936,98104,428254,391366,414858,699859,581246,605852,493780,596781,392253,938200,235699,379555,207161,819130,443486,81069,997681,712083,121707,72929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]