SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417254 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417254 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617116,738881,489780,1047096,776830,1022583,20899,994991,812827,485997,310223,674963,17686,724519,7193,152234,666437,719888,917655,903982,331733,307520,153316,37178,423971,394470,696326,195928,468813,892592,595753,1040785,453103,348454,336646,632714,846832,457662,977322,252207,608016,357047,1018719,172830,852953,686197,1027945,317370,667005,567590,210723,674207,309569,247793,879085,502289,748498,633625,49372,651727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]