SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527833 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527833 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281590,282484,200242,234570,762721,980986,425244,577386,862843,690626,148562,442481,471272,110849,34014,772401,993367,824848,451655,715477,402439,747098,909073,817975,532500,288545,796896,162818,745962,947897,695776,973945,516468,904340,480396,999121,881761,221576,409704,904191,678659,369767,263545,53518,1045059,491632,858393,953647,923658,354274,742049,519579,547370,249945,945288,569964,158414,642432,907364,455593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001002s ]