SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446821 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446821 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409904,471724,538461,783527,288810,107723,115878,36668,609287,68730,278997,619299,969217,945577,814748,287899,579563,228143,931207,137888,289592,792211,580564,635231,939845,54552,218114,976882,867529,560987,1021300,487586,942244,766844,196158,307288,180751,156120,634649,599949,765371,409124,415882,215970,526329,9524,1043392,156645,321088,869223,543618,110884,206715,818077,147214,72565,108782,910489,248363,595311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]