SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381904 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381904 [ RunTime:0.006680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654121,765903,645626,616714,714411,1022391,696321,760153,383409,873081,928218,742054,193936,775924,951081,86242,381690,809190,343792,1003831,308613,864379,892511,743022,86619,791516,302859,363925,327528,156520,234005,99942,175671,40348,424938,872065,10652,251906,428988,664073,624973,1002897,644732,406706,484733,772648,187053,279867,630142,522244,284172,735515,68521,360903,595359,488437,746092,792641,18673,784082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]