SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518062 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518062 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567249,362854,70502,45144,768610,923968,421806,882880,738617,139101,705371,84428,422182,1024165,212216,314923,328191,278550,767608,930972,586086,769313,920996,573775,100271,264059,289101,787596,642041,156242,1016124,866234,204213,895751,601372,582790,145692,20610,216868,244491,938713,100724,981161,918435,82048,174550,662191,19882,1012949,256200,646257,709077,624606,172,457443,715600,66439,104005,713277,187296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002146s ]