SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001857s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488838 LIMIT 1 [ RunTime:0.000705s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488838 [ RunTime:0.003524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491957,670014,826143,1003208,765999,82023,427615,83983,765725,861078,156670,114598,519217,144376,1019803,17688,303671,971112,130709,95831,103574,955059,879367,342169,662178,875926,437170,564340,964399,404434,930655,464702,1002417,778469,29366,982722,554366,271514,70398,513153,999159,272842,517285,241066,709580,801601,680027,366092,976360,828606,401672,1008986,1033137,171359,171417,656115,375232,640455,939369,1024452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]