SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417618 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417618 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13918,520483,433947,243290,500641,482119,461578,248107,993401,790822,378011,156653,157562,107543,29764,1044620,488820,892593,640271,920622,457309,203711,592532,85378,1039197,906135,195029,201752,648078,633862,659001,40572,971439,405218,826194,267779,986982,819816,670779,345361,85304,556495,640772,435945,368522,995353,168408,345410,507829,495048,577557,977446,970137,854381,612078,799531,960936,265648,48618,275374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]